use [databasename]
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id =(object_id('trgMessageTypeSetNotification')) AND type in (N'TR'))
begin
	drop trigger [trgMessageTypeSetNotification]
end
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id =(object_id('trgserviceProviderSetNotification')) AND type in (N'TR'))
begin
	drop trigger [trgServiceProviderSetNotification]
end

GO